중프

테이블 (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)