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