market
Tables (8)
bank (Untitled8)
- account (Field) — varchar(30) — NOT NULL
- bank (Field2) — varchar(10) — NOT NULL
- name (Field3) — varchar(10) — NOT NULL
board (Untitled7)
- num (Key) — Primary key — NOT NULL — auto_increment
- writer (Field) — varchar(50) — NOT NULL
- subject (Field2) — varchar(50)
- content (Field3) — text — NOT NULL
- passwd (Field4) — varchar(60) — NOT NULL
- reg_date (Field5) — datetime — NOT NULL
- ip (Field6) — varchar(30) — NOT NULL
- readcount (Field7) — int — default 0
- ref (Field8) — int — NOT NULL
- re_step (Field9) — smallint — NOT NULL
- re_level (Field10) — smallint — NOT NULL
buy (Untitled6)
- clothes_id (Key) — int — Foreign key → clothes.clothes_id — NOT NULL — auto_increment
- buy_id (Field) — bigint — NOT NULL
- buyer (Field2) — varchar(50) — NOT NULL
- clothes_name (Field4) — varchar(100) — NOT NULL
- buy_price (Field5) — int — NOT NULL
- buy_count (Field6) — tinyint — NOT NULL
- buy_image (Field7) — varchar(16) — default 'nothing.jsp'
- buy_date (Field8) — datetime — NOT NULL
- account (Field9) — varchar(50) — NOT NULL
- deliveryName (Field10) — varchar(10) — NOT NULL
- deliveryTel (Field11) — varchar(20) — NOT NULL
- deliveryAddress (Field12) — varchar(100) — NOT NULL
- sanction (Field13) — varchar(10) — default '상품준비중'
cart (Untitled5)
- cart_id (Key) — int — Primary key — NOT NULL — auto_increment
- clothes_id (Key2) — int — Foreign key → clothes.clothes_id — NOT NULL — auto_increment
- buyer (Field) — varchar(50) — NOT NULL
- clothes_name (Field3) — varchar(100) — NOT NULL
- buy_price (Field4) — int — NOT NULL
- buy_count (Field5) — tinyInt — NOT NULL
- clothes_images (Field6) — varchar(16) — default 'nothing.jpg'
- Field7
clothes (Untitled3)
- clothes_id (Key) — int — Primary key — NOT NULL — auto_increment
- clothes_kind (Field) — varchar(3) — NOT NULL
- clothes_name (Field2) — varchar(100) — NOT NULL
- clothes_price (Field3) — int — NOT NULL
- clothes_count (Field4) — smallint — NOT NULL
- clothes_images (Field5) — varchar(16) — default 'nothing.jpg'
- clothes_content (Field6) — text — NOT NULL
- discount_rate (Field7) — tinyint — default 10
- reg_date (Field8) — datetime — NOT NULL
manager (Untitled)
- managerid (Key) — varchar(45) — Primary key — NOT NULL
- managerPasswd (Field) — varchar(60) — NOT NULL
member (Untitled2)
- id (Key) — VARCHAR(50) — Primary key — NOT NULL
- passwd (Field) — varchar(16) — NOT NULL
- name (Field2) — varchar(10) — NOT NULL
- reg_date (Field3) — datetime — NOT NULL
- address (Field4) — varchar(16) — NOT NULL
- tel (Field5) — varchar(10) — NOT NULL
qna (Untitled4)
- qna_id (Key) — int — Primary key — NOT NULL — auto_increment
- clothes_id (Key2) — int — Foreign key → clothes.clothes_id — NOT NULL — auto_increment
- clothes_name (Field2) — varchar(100) — NOT NULL
- qna_writer (Field3) — varchar(50) — NOT NULL
- qna_content (Field4) — text — NOT NULL
- group_id (Field5) — int — NOT NULL
- qora (Field6) — tinyint — NOT NULL
- reply (Field7) — tinyint — default 0
- reg_date (Field8) — datetime — NOT NULL