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