# 黛茶

**Repository Path**: OutsourcingService/MateTea

## Basic Information

- **Project Name**: 黛茶
- **Description**: 黛茶
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2017-08-06
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#黛茶

create database tea;

show databases;

====== t_application  ======

CREATE TABLE IF NOT EXISTS `t_application`(
   `id` INT AUTO_INCREMENT,
   `username` VARCHAR(50),
   `sex` INT(20),
   `phone` VARCHAR(50),
	`marital` INT(20),
	`address` VARCHAR(100),
	`joinArea` VARCHAR(100),
	`alternativeArea` VARCHAR(100),
	`budget` VARCHAR(50),
	`education` VARCHAR(100),
	`major` VARCHAR(100),
	`proprietaryExperience` VARCHAR(800),
	`managementExperience` VARCHAR(800),
	`workExperience` VARCHAR(800),
	PRIMARY KEY ( `id` )
) DEFAULT CHARSET=utf8;

====== t_area  ======

CREATE TABLE IF NOT EXISTS `t_area`(
   `id` INT AUTO_INCREMENT,
	`areaName` VARCHAR(200),
	PRIMARY KEY ( `id` )
) DEFAULT CHARSET=utf8;

====== t_investigate  ======

CREATE TABLE IF NOT EXISTS `t_investigate`(
   `id` INT AUTO_INCREMENT,
   `visitingTime` VARCHAR(50),
   `visitingPeopleNumber` VARCHAR(20),
   `username` VARCHAR(50),
	`phone` VARCHAR(50),
	`areaId` INT(50),
	PRIMARY KEY ( `id` )
) DEFAULT CHARSET=utf8;

====== t_message  ======

CREATE TABLE IF NOT EXISTS `t_message`(
   `id` INT AUTO_INCREMENT,
   `username` VARCHAR(50),
   `phone` VARCHAR(50),
   `message` VARCHAR(500),
	`date` VARCHAR(50),
	`address` VARCHAR(100),
	PRIMARY KEY ( `id` )
) DEFAULT CHARSET=utf8;

====== t_post  ======

CREATE TABLE IF NOT EXISTS `t_post`(
   `id` INT AUTO_INCREMENT,
   `postName` VARCHAR(200),
   `desc` TEXT,
   `requirements` TEXT,
	`imgPath` TEXT,
	`postTypeId` INT(100),
	PRIMARY KEY ( `id` )
) DEFAULT CHARSET=utf8;

====== t_postType  ======

CREATE TABLE IF NOT EXISTS `t_postType`(
   `id` INT AUTO_INCREMENT,
   `posttypeName` VARCHAR(200),
	PRIMARY KEY ( `id` )
) DEFAULT CHARSET=utf8;

====== t_product  ======

CREATE TABLE IF NOT EXISTS `t_product`(
   `id` INT AUTO_INCREMENT,
   `produceName` VARCHAR(200),
   `imgPath` TEXT,
   `desc` TEXT,
	`price` DOUBLE,
	`discount` DOUBLE,
	`seriesId` INT(100),
	PRIMARY KEY ( `id` )
) DEFAULT CHARSET=utf8;

====== t_series  ======

CREATE TABLE IF NOT EXISTS `t_series`(
   `id` INT AUTO_INCREMENT,
   `seriesName` VARCHAR(200),
	PRIMARY KEY ( `id` )
) DEFAULT CHARSET=utf8;


====== t_store  ======

CREATE TABLE IF NOT EXISTS `t_store`(
   `id` INT AUTO_INCREMENT,
   `storeName` VARCHAR(200),
   `address` VARCHAR(200),
   `desc` TEXT,
	`imgPath` TEXT,
	`areaId` INT(100),
	`produceId` INT(100),
	PRIMARY KEY ( `id` )
) DEFAULT CHARSET=utf8;