pickbody_yeo_no

Tables (16)

Copy Of Untitled (PB_Member_ProfilePhoto)

  • Key (profilephoto_no) — NUMBER — Primary key — NOT NULL
  • member_no — NUMBER — Foreign key → PB_Member.member_no — NOT NULL
  • Field (profilephoto_link) — VARCHAR2(100)
  • Field (profilephoto_original_filename) — VARHCAR2(100)

PB_Admin

  • admin_no — NUMBER — Primary key — NOT NULL
  • admin_id — VARCHAR2(20)
  • admin_pw — VAHCHAR2(200)

PB_Board_Drop

  • drop_no — NUMBER — Primary key — NOT NULL
  • drop_title — VARCHAR2(200)
  • drop_content — VARCHAR2(4000)
  • Field (drop_amount) — NUMBER
  • Field (drop_price) — NUMBER
  • drop_startdate — DATE
  • drop_enddate — DATE
  • drop_writedate — DATE

PB_List_Application (PB_Application)

  • application_no — NUMBER — Primary key — NOT NULL
  • drop_no — NUMBER — Foreign key → PB_Board_Drop.drop_no — NOT NULL
  • member_no — NUMBER — Foreign key → PB_Member.member_no — NOT NULL
  • Field (application_comment) — VARCHAR2(400)
  • Field (application_date) — DATE

PB_List_Winning

  • winning_no — NUMBER — Primary key — NOT NULL
  • drop_no — NUMBER — Foreign key → PB_Board_Drop.drop_no — NOT NULL
  • member_no — NUMBER — Foreign key → PB_Member.member_no — NOT NULL

PB_Member

  • member_no — NUMBER — Primary key — NOT NULL
  • member_id — VARCHAR2(50)
  • member_pw — VARCHAR2(200)
  • member_name — VARCHAR2(100)
  • member_gender — VARHCHAR2(2)
  • member_nick — VARCHAR2(200)
  • member_birth — DATE
  • member_address — VARCHAR2(200)
  • member_phone — VARCHAR2(50)
  • member_email — VARCHAR2(100)
  • member_joindate — DATE
  • member_point — NUMBER
  • member_manner — NUMBER

PB_Member_Goal

  • goal_no — NUMBER — Primary key — NOT NULL
  • goal_name — VARCHAR2(50)

PB_Member_Point_History

  • point_history_no — NUMBER — Primary key — NOT NULL
  • member_no — NUMBER — Foreign key → PB_Member.member_no — NOT NULL
  • point_history_usaway — VARCHAR2(200)
  • point_history_amount — NUMBER
  • point_history_date — DATE

Untitled (PB_Goal_Choice)

  • Key (choice_no) — NUMBER — Primary key — NOT NULL
  • goal_no — NUMBER — Foreign key → PB_Member_Goal.goal_no — NOT NULL
  • member_no — NUMBER — Foreign key → PB_Member.member_no — NOT NULL

Untitled (PB_Board_Drop_Image)

  • Key (image_no) — NUMBER — Primary key — NOT NULL
  • drop_no — NUMBER — Foreign key → PB_Board_Drop.drop_no — NOT NULL
  • Field (image_link) — VARCHAR2(100)
  • Field (image_original_filename) — VARHCAR2(100)

Untitled (PB_Member_Inbody)

  • Key (inbody_no) — NUMBER — Primary key — NOT NULL
  • member_no — NUMBER — Foreign key → PB_Member.member_no — NOT NULL
  • Field (inbody_stature) — NUMBER
  • Field (inbody_weight) — NUMBER
  • Field (inbody_skeletalmusclemass) — NUMBER
  • Field (inbody_bodyfatmass) — NUMBER
  • Field2 (inbody_measureddate) — DATE
  • Field (inbody_writedate) — DATE

Untitled (PB_Member_inhibition)

  • Key (inhibition_no) — NUMBER — Primary key — NOT NULL
  • member_no — NUMBER — Foreign key → PB_Member.member_no — NOT NULL
  • Field (inhibition_date) — DATE
  • Field (inhibition_resistdate) — DATE

Untitled (board)

  • Key (board_no) — NUMBER — Primary key — NOT NULL
  • Field

Untitled (member)

  • Key (member_no) — NUMBER — Primary key — NOT NULL
  • Field

Untitled (review)

  • Key (reivw_no) — NUMBER — Primary key — NOT NULL
  • Key (board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (image)

  • Key (image_no) — Primary key — NOT NULL
  • Key (reivw_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL