중프
테이블 (17)
-
- weather_no — number — 기본 키 — NOT NULL
- weather_day — number
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
Board
- board_no — number — 기본 키 — NOT NULL
- code_number — number — 외래 키 → Type.code_number — NOT NULL
- board_name — varchar2(50)
- board_content — varchar2(4000)
- board_date — date
- board_update — VARCHAR(255)
- board_delyn — char(2)
- board_click — number
- board_tag — VARCHAR(255)
- Field — VARCHAR(255)
CopyOfCopyOflike
- li_no — number — 기본 키 — NOT NULL
- board_no — number — NOT NULL
- code_number — number — NOT NULL
CopyOflike
- li_no — number — 기본 키 — NOT NULL
- reply_no — number — NOT NULL
- board_no — number — NOT NULL
- code_number — number — NOT NULL
CopyOfreply
- reply_no — number — 기본 키 — NOT NULL
- reply_no2 — number — 외래 키 → reply.reply_no — NOT NULL
- board_no — number — 외래 키 → reply.board_no — NOT NULL
- code_number — number — 외래 키 → reply.code_number — NOT NULL
- board_content — varchar2(4000)
- board_date — date
- board_delyn — char(2)
Member
- mem_no — number — 기본 키 — NOT NULL — 회원번호
- mem_id — varchar2(20)
- mem_pwd — varchar2(20)
- mem_name — varchar2(20)
- mem_alias — varchar2(20)
- mem_mbti — char(4)
- mem_reg — number
- mem_reg2 — number
- mem_age — age
- mem_gender — varchar(2)
- mem_tel — number
- mem_email — varchar2(40)
- mem_delYn — varchar2(2)
- mem_join_date — date
- mem_mileage — number
- mem_pro_name — varchar2(20)
Type
- code_number — number — 기본 키 — NOT NULL
- code_name — varchar2(200)
- mem_no — number — NOT NULL — 회원번호
WEATHER
- weather_no — number — 기본 키 — NOT NULL
- weather_day — number
board
- board_no — number — 기본 키 — NOT NULL
- board_type — number
- board_name — varchar2(50)
- board_content — varchar2(4000)
- board_date — date
- board_delyn — char(2)
- board_click — number
- board_comment — varchar2(400)
- board_comment2 — varchar2(400)
coupon
- cup_no — number — 기본 키 — NOT NULL
- mem_no — number — 외래 키 → Member.mem_no — NOT NULL — 회원번호
- cup_name — varchar2(10)
- cup_date — date
- cup_discount — number
file_board
- fb_no — number — 기본 키 — NOT NULL
- mem_no — number — 외래 키 → Member.mem_no — NOT NULL — 회원번호
- fb_org_name — varchar2(50)
- fb_save_name — varchar2(50)
- fb_exe — varchar2(10)
- fb_size — number
- fb_date — date
- fb_delyn — varchar2(2)
- fb_path — varchar2(100)
like
- li_no — number — 기본 키 — NOT NULL
- reply_no — number — NOT NULL
- reply_no2 — number — NOT NULL
- board_no — number — NOT NULL
- code_number — number — NOT NULL
payment
- pay_no — number — 기본 키 — NOT NULL
- pay_date — date
- pay_method — varchar2(20)
- pay_status — varchar2(20)
- pay_price — number
- pay_delyn — char(2)
refund
- refund_no — number — 기본 키 — NOT NULL
- refund_date — date
- refund_reason — varchar2(100)
- refund_status — varchar2(20)
reply
- reply_no — number — 기본 키 — NOT NULL
- board_no — number — 외래 키 → Board.board_no — NOT NULL
- code_number — number — 외래 키 → Board.code_number — NOT NULL
- board_content — varchar2(4000)
- board_date — date
- board_delyn — char(2)
report
- re_no — number — 기본 키 — NOT NULL
- mem_no — number — 외래 키 → Member.mem_no — NOT NULL — 회원번호
- weather_no — number — 외래 키 → -.weather_no — NOT NULL
- re_reason — number
- re_comment — varchar2(100)
- re_status — varchar2(20)
- re_reciept_date — date
- re_clear_date — date
reservation
- tp_no — number — 기본 키 — NOT NULL
- mem_no — number — 외래 키 → Member.mem_no — NOT NULL — 회원번호
- tp_title — varchar2(10)
- tp_context — varchar2(2000)
- tp_create_date — date
- tp_update_date — date
- tp_delYn — varchar2(2)
- tp_weather — varchar2(10)