kosmo126

테이블 (19)

Untitled (live)

  • Key (live_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (live_price) — NUMBER(20) — NOT NULL
  • Field2 (live_id) — VARCHAR(25) — NOT NULL
  • Field3 (live_nick) — VARCHAR(25) — NOT NULL
  • Field4 (live_content) — VARCHAR(25) — NOT NULL
  • Field5 (live_emotion) — VARCHAR(25) — NOT NULL
  • Field6 (live_count) — NUMBER(20) — NOT NULL
  • Field7 (live_pdName) — VARCHAR(25) — NOT NULL
  • Field8 (live_pdCount) — NUMBER(20) — NOT NULL
  • Field9 (live_title) — VARCHAR(25) — NOT NULL

Untitled (ad_account)

  • Key (ad_ac_code) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (ac_cost) — NUMBER(20) — NOT NULL
  • Field2 (ac_code) — NUMBER(20) — NOT NULL
  • Field3 (ac_deCost) — NUMBER(20) — NOT NULL

Untitled (delivery)

  • Key (de_code) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (de_area) — VARCHAR(25) — NOT NULL
  • Field2 (de_driver) — VARCHAR(25) — NOT NULL
  • Field3 (de_cost) — NUMBER(20) — NOT NULL
  • Field4 (de_state) — VARCHAR(25) — NOT NULL
  • Field5 (de_product) — VARCHAR(25) — NOT NULL

Untitled (storage)

  • Key (st_code) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (st_location) — VARCHAR(25) — NOT NULL
  • Field2 (st_state) — VARCHAR(25) — NOT NULL
  • Field3 (st_category) — VARCHAR(25) — NOT NULL
  • Field4 (st_manager) — VARCHAR(25) — NOT NULL

Untitled (biz)

  • Key (biz_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (biz_name) — VARCHAR(25) — NOT NULL
  • Field2 (biz_tell) — VARCHAR(25) — NOT NULL
  • Field3 (biz_address) — VARCHAR(25) — NOT NULL
  • Field4 (biz_explain) — VARCHAR(25) — NOT NULL

Untitled (reply)

  • Key (bc_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (bc_writer) — VARCHAR(25) — NOT NULL
  • Field2 (bc_bdno) — NUMBER(20) — NOT NULL
  • Field3 (bc_content) — VARCHAR(25) — NOT NULL
  • Field4 (bc_regDate) — date — NOT NULL
  • Field5 (bc_group) — VARCHAR(25) — NOT NULL
  • Field6 (bc_depth) — VARCHAR(25) — NOT NULL

Untitled (question)

  • Key (fre_askquestion) — VARCHAR(25) — 기본 키 — NOT NULL
  • Field (fre_answer) — VARCHAR(25) — NOT NULL

Untitled (crawling)

  • Key (cr_pdNo) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (cr_pdName) — VARCHAR(25) — NOT NULL
  • Field2 (cr_pdPrice) — NUMBER(20) — NOT NULL
  • Field3 (cr_pdImg) — VARCHAR(25) — NOT NULL

Untitled (ac_chat)

  • Key (chat_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (cus_id) — VARCHAR(25) — NOT NULL
  • Field2 (chat_content) — VARCHAR(25) — NOT NULL
  • Field3 (chat_from) — VARCHAR(25) — NOT NULL
  • Field4 (chat_to) — VARCHAR(25) — NOT NULL
  • Field5 (chat_time) — timestamp — NOT NULL
  • Field6 (chat_file) — VARCHAR(25) — NOT NULL
  • Field7 (chat_notice) — VARCHAR(25) — NOT NULL

Untitled (map)

  • Key (map_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (pd_no) — NUMBER(20) — NOT NULL

Untitled (calendar)

  • Key (cal_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (cal_content) — VARCHAR(25) — NOT NULL
  • Field2 (cal_pdName) — VARCHAR(25) — NOT NULL
  • Field3 (cal_start) — date — NOT NULL
  • Field4 (cal_end) — date — NOT NULL
  • Field5 (in_no) — NUMBER(20) — NOT NULL

Untitled (temperature)

  • Key (tm_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (tm_cusId) — VARCHAR(25) — NOT NULL
  • Field2 (tm_pdNo) — NUMBER(20) — NOT NULL
  • Field3 (tm_pdName) — VARCHAR(25) — NOT NULL
  • Field4 (tm_sellDate) — date — NOT NULL
  • Field5 (tm_sellGrade) — VARCHAR(25) — NOT NULL
  • Field6 (tm_sellComent) — VARCHAR(25) — NOT NULL

Untitled (account)

  • Key (ac_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (ac_cusId) — VARCHAR(25) — NOT NULL
  • Field2 (ac_pdNo) — NUMBER(20) — NOT NULL

Untitled (interest)

  • Key (in_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (in_pdNo) — NUMBER(20) — NOT NULL

Untitled (buy)

  • Key (by_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (by_pdNo) — NUMBER(20) — NOT NULL
  • Field2 (by_pdName) — VARCHAR(25) — NOT NULL
  • Field3 (by_price) — NUMBER(20) — NOT NULL
  • Field4 (by_address) — VARCHAR(45) — NOT NULL
  • Field5 (by_delivery) — VARCHAR(25) — NOT NULL
  • Field6 (by_fee) — NUMBER(20) — NOT NULL
  • Field7 (by_status) — VARCHAR(25) — NOT NULL
  • Field8 (by_sellerId) — VARCHAR(25) — NOT NULL
  • Field9 (by_sellerTemperature) — NUMBER(20) — NOT NULL
  • Field10 (by_date) — date — NOT NULL

Untitled (sell_info)

  • Key (se_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (se_pdNo) — NUMBER(20) — NOT NULL
  • Field2 (se_name) — VARCHAR(25) — NOT NULL
  • Field3 (se_endPrice) — NUMBER(20) — NOT NULL
  • Field4 (se_price) — NUMBER(20) — NOT NULL
  • Field5 (se_date) — date — NOT NULL
  • Field6 (se_temperature) — NUMBER(20) — NOT NULL
  • Field7 (se_totalAmount) — NUMBER(20) — NOT NULL
  • Field8 (se_totalPrice) — NUMBER(20) — NOT NULL

Untitled (delivery_cost)

  • Key (de_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (de_sellState) — VARCHAR(25) — NOT NULL
  • Field2 (de_cusState) — VARCHAR(25) — NOT NULL
  • Field3 (de_weight) — NUMBER(20) — NOT NULL
  • Field4 (de_size) — NUMBER(20) — NOT NULL
  • Field5 (de_rank) — VARCHAR(25) — NOT NULL
  • Field6 (de_fee) — NUMBER(20) — NOT NULL

Untitled (product)

  • Key (pd_no) — NUMBER(20) — 기본 키 — NOT NULL
  • Field (pd_name) — VARCHAR(25) — NOT NULL
  • Field2 (pd_img) — VARCHAR(100) — NOT NULL
  • Field3 (pd_startPrice) — NUMBER(20) — NOT NULL
  • Field4 (pd_endPrice) — NUMBER(20) — NOT NULL
  • Field5 (pd_price) — NUMBER(20) — NOT NULL
  • Field6 (pd_fee) — NUMBER(20) — NOT NULL
  • Field7 (pd_delivery) — NUMBER(20) — NOT NULL
  • Field8 (pd_status) — VARCHAR(25) — NOT NULL
  • Field9 (pd_return_status) — VARCHAR(25) — NOT NULL
  • Field (pd_early_status) — VARCHAR(25) — NOT NULL
  • Field2 (pd_startDate) — date — NOT NULL
  • Field3 (pd_endDate) — date — NOT NULL
  • Field4 (pd_view) — NUMBER(20) — NOT NULL

고객 (customer)

  • 고객키 (cus_id) — VARCHAR(25) — 기본 키 — NOT NULL
  • 고객비밀번호 (cus_pw) — VARCHAR(25) — NOT NULL
  • Field2 (cus_name) — VARCHAR(25) — NOT NULL
  • Field3 (cus_birthday) — VARCHAR(25) — NOT NULL
  • Field4 (cus_address) — VARCHAR(25) — NOT NULL
  • Field5 (cus_ph) — NUMBER(20) — NOT NULL
  • Field6 (cus_email) — VARCHAR(25) — NOT NULL
  • Field7 (cus_card) — VARCHAR(25) — NOT NULL
  • Field8 (cus_grade) — VARCHAR(25) — NOT NULL
  • Field9 (cus_rank) — VARCHAR(25) — NOT NULL
  • Field10 (cus_key) — VARCHAR(25) — NOT NULL
  • Field11 (cus_authority) — VARCHAR(25) — NOT NULL
  • Field12 (cus_enabled) — VARCHAR(25) — NOT NULL
  • Field (cus_regdate) — VARCHAR(25) — NOT NULL