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